package com.tunan.persistence.dao.sck;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.tunan.persistence.model.TSysUser;

public interface TSysUserMapper extends EntityMapper<TSysUser> {
	@Select("select * from toonan.T_SYS_USER")
	public List<TSysUser> findAll();
	/**
	 * 
	 * @param tSysUser void
	 * @todo  根据登陆名（DLM）查找用户
	 * @date 2016年3月22日
	 * @author kinda
	 */
	@Select("select * from T_SYS_USER r where r.DLM= #{dlm} AND r.DLKL=#{dlkl}")
	public TSysUser findByDlm(TSysUser tSysUser);
	
	@Select("select TN_SEQ_COMMON.nextval")
	public Long getCommonSequence();

	public List<TSysUser> findUserByRoleId(String id);
	
}
